MacWorld 1996 July

home *** CD-ROM | disk | FTP | other *** search

/ MacWorld 1996 July / Macworld (1996-07).dmg / System 7.5 Update 2.0 / FileMaker Pro 3.0 CD Extras / FileMaker Examples / Templates w⁄data / Business / Expense Report (.txt) < prev next >

Wrap

FileMaker Pro Database | 1996-01-25 | 132KB | 941 lines

HBAM2016AUG95 Pro 3.0 @4=P- wNJF? HBAM3016AUG95@ Pro 2.0 - 2.1F! Pro 3.0 Franz App AMOUNT 1 AMOUNT 2 AMOUNT 3 AMOUNT 4 AMOUNT 5 AMOUNT 6 AMOUNT 7 AMOUNT REIMB APPROVED BY CREATED BY DATE 1 DATE 2 DATE 3 DATE 4 DATE 5 DATE 6 DATE 7 DATE APPROVED DATE CREATED DATE EMP SIGNED DATE MODIFIED DATE OF END OF WEEK DATE REIMBURSED DEPARTMENT EMPLOYEE ID EXPENSE RPRT ID EXPENSE TYPE @ EXTENSION FIRST NAME GRAND TOTAL e LAST NAME MILE 1 MILE 2 MILE 3 MILE 4 MILE 5 MILE 6 MILE 7 MILE DOLLARS 1 MILE DOLLARS 2 MILE DOLLARS 3 MILE DOLLARS 4 MILE DOLLARS 5 MILE DOLLARS 6 MILE DOLLARS 7 PROJECT PURPOSE OF TRIP RATE PER MILE SUBTOTAL 1 SUBTOTAL 2 SUBTOTAL 3 SUBTOTAL 4 SUBTOTAL 5 SUBTOTAL 6 SUBTOTAL 7 SUBTTL MILE AMNT SUBTTLS WEEK Sunday Monday Tuesday Wednesday Thursday Friday Saturday January February March April August September October November December 1st Quarter 2nd Quarter 3rd Quarter 4th Quarter 11/20/95 Expense Rprt IDB Date CreatedB Date ModifiedB Date 1B 3 - 6 Date 2B 3 - 5 Date 3B 3 - 4 Date 4B 3 - 3 Date 5B 3 - 2 Date of End of WeekB Date 6B 3 - 1 Amount 1 Description This file contains all the line items on an invoice. It can be used by itself, but it is intended to be used as a relational database with the Purchase Order template. By keeping the line items in a separate file, you have more flexibility than you would if you used a repeating field. How to use this solution Each invoice should have one P.O. number. This number groups all the line items in the invoice. Later, you can search on this number (or use a relation from another datab ase) to print an invoice. Run the Purchase Order report to see an example invoice. How to customize this solution You can integrate this database with several other databases in a relational scheme. An Invoices database could organize the invoices, using customer information from a Customers database. A Parts or Products database could be linked to the Part No. field, so that the description and price are entered automatically. Amount 2B Amount 3B Amount 4B Amount 5B Amount 6B Amount 7B Employee IDB First NameB ?A Last NameB Expense TypeB Subtotal 1B 5) + Subtotal 2B 6) + Subtotal 3B 7) + Subtotal 4B 8) + Subtotal 5B 9) + Subtotal 6B ;) + Subtotal 7B <) + Grand TotalB Q) + Rate per MileB Mile 1B Mile 2B Mile 3B Mile 4B Mile 5B Mile 6B Mile 7B Subttls WeekB Date 7B Mile Dollars 1B Mile Dollars 2B Mile Dollars 3B Mile Dollars 4B Mile Dollars 5B Mile Dollars 6B Mile Dollars 7B Subttl Mile AmntB DepartmentB ProjectB Purpose of TripB Created ByB Date ReimbursedB Amount ReimbB Date Emp SignedB Approved ByB Date ApprovedB dA ExtensionB InfoB A Form View A List View Expense Report Information Report Menu A Form ViewB Yesfter Noarter Yesfter Noarter Yesfter Noarter Yesfter Noarter A List ViewB Yesfter Noarter Yesfter Noarter Yesfter Noarter Yesfter Noarter Yesfter Noarter Yesfter Noarter Yesfter Noarter Yesfter Noarter Yesfter Noarter Yesfter Noarter Yesfter Noarter Yesfter Noarter Yesfter Noarter Yesfter Noarter Yesfter Noarter Yesfter Noarter Yesfter Noarter Yesfter Noarter Yesfter Noarter Yesfter Noarter Yesfter Noarter Yesfter Noarter Yesfter Noarter Yesfter Noarter Yesfter Noarter Yesfter Noarter Yesfter Noarter Yesfter Noarter Yesfter Noarter Yesfter Noarter Yesfter Noarter Yesfter Noarter Yesfter Noarter Yesfter Noarter Yesfter Noarter Yesfter Noarter Yesfter Noarter Yesfter Noarter Yesfter Noarter Yesfter Noarter Yesfter Noarter Yesfter Noarter Yesfter Noarter Yesfter Noarter Yesfter Noarter Your Own Button Your Own Button Record Delete Record Record Reports View As View As Close Totals: Miles: Date: Totals Amount Date Reimbursed Purpose of Trip Project Dept. Rate/ Week Ending ~ Extension Last Name First Name Emp. ID Report ID Enter data for Expenses Expense ReportB Yesfter Noarter Yesfter Noarter Yesfter Noarter Yesfter Noarter Yesfter Noarter Yesfter Noarter Yesfter Noarter Amount` Reimb.a Totalb Weekc Last Named First Namee Report IDf Your Own Buttong Your Own Buttonh Recordi Delete Recordj Recordk Reportsl View As Listm View As Formn Closeo Infop3Click to see more information for an Expense Report InformationB Yesfter Noarter Yesfter Noarter Yesfter Noarter Yesfter Noarter Yesfter Noarter Yesfter Noarter Yesfter Noarter Yesfter Noarter Yesfter Noarter Yesfter Noarter Yesfter Noarter Yesfter Noarter Yesfter Noarter Yesfter Noarter Yesfter Noarter Yesfter Noarter Yesfter Noarter Yesfter Noarter Yesfter Noarter Yesfter Noarter Yesfter Noarter Yesfter Noarter Yesfter Noarter Yesfter Noarter Yesfter Noarter Yesfter Noarter Yesfter Noarter Yesfter Noarter Yesfter Noarter Yesfter Noarter Yesfter Noarter Yesfter Noarter Yesfter Noarter Yesfter Noarter Yesfter Noarter Yesfter Noarter Yesfter Noarter Yesfter Noarter Yesfter Noarter Yesfter Noarter Yesfter Noarter Yesfter Noarter Your Own Button Reports View As View As Close Rev. 09/17/95 z<Please return completed form to accounts payable department. Manager Signature Employee Signature Date Reimbursed Amount Reimb Totals: Miles: Totals Dates: Rate/Mile Purpose of Trip Project Dept. Emp. ID Last Name First Name Week Ending Report ID Expense Report Company Name and Logo Report MenuB Your Own ButtonI ReportsJ View As ListK View As FormL CloseM InfoO.Information about the Expense Reports solutionP Info for this Solution bout the Expense Reports solutionP Info for this Solution Your Own ReportB Your Own ReportC Your Own ReportD Expense ReportE Your Own ButtonF ReportsG View As ListH View As FormI CloseJ InfoK>Click on any of these buttons to preview the respective reportL Select a report ButtonF ReportsG View As ListH View As FormI CloseJ InfoK>Click on any of these buttons to preview the respective reportL Select a report 05/09/95Y 10/9/95n 7/29/91o 7/30/91p 7/31/91q 8/1/91r 8/2/91s 8/4/91t 8/3/91u 135.6 60.32 Pamela Air, Rail, Bus Taxi, Limousine Lodging Telephone Personal Meals Business Meals Entertainment 139.3 224.93 145.32 1414.55 114.62 135.6 8/4/91 [ Marketing Demo Files ]&Go to Office Supplies Expo in San Jose Paul Farrah 9/1/91 1414.55 05/09/95Y 05/09/95n 7/8/91o 7/9/91p 7/10/91q 7/11/91r 7/12/91s 7/14/91t 7/13/91v Dennis Emmet Personal Meals 7/14/91 [ Marketing Plan Launch ]LWork with marketing consultants on materials for launch of new product line. Paul Farrah 05/09/95Y 05/09/95n 7/22/91o 7/23/91p 7/24/91q 7/25/91r 7/26/91s 7/28/91 Your Own ButtonB ReportsC View As ListD View As FormE CloseF 7/27/91x 25.7~ Janet Swanson Taxi, Limousine Personal Meals 7/28/91 Operations Shipping System ]%Go to seminar on new shipping system. Paul Farrah Sort by Expense Report ID Sort by Last Name Sort by Date of End of Week Expense Report Open Script Yesfter Noarter Helvetica Geneva Times Times New Roman Arial MS Sans Serif Sort by Expense Report ID Expense Report Sort by Last Name Sort by Date of End of Week Open Script )=400 Cancel You did not enter any find criteria; all records will be displayed.C) wwwwww ffffff UUUUUU DDDDDD 3333B """""" wwxwwxw ggvgvv gvwxgwghg vhgvvww fvfgfwffv eVefefe VvffVefVVefUe\ ffFdeefeefddfDeVdfEdfFdffk EUeFFEUFEUFFUeTeVFeUUdVEEk UTdUTeETeETeEUFTUTUFTUUTeK TEETEETUETUETUDUDEETUDTUE[ 4CDD4E4ET D4DD4CDDC C3C3C34C4C3CC43C "#""3"129 #11#22122"3! wwwwww ffffff UUUUUU DDDDDD 3333B """""" #11#22122"3! "#""3"129 C3C3C34C4C3CC43C DDCD4DD4CDDC 4CDD4E4ET TEETEETUETUETUDUDEETUDTUE[ dUTeETeETeEUFTUTUFTUUTeK EUeFFEUFEUFFUeTeVFeUUdVEEk ffFdeefeefddfDeVdfEdfFdffk eVefefe VvffVefVVefUe\ fvfgfwffv ggvgvv gvwxgwghg vhgvvww Ejwwg wwxwwxw (LIST LISTA Auto Rental Tolls and Parking Air, Rail, Bus Taxi, Limousine Lodging Telephone Personal Meals Banquet Meals Business Meals Entertainment VDEFA( (LIST VDEFA( Expense Type ListB Project List wwwwww ffffff UUUUUU DDDDDD wwffeffg@ veUEDDCC vUTDD44 vUDDC32 #""# weUDD3 veTDC2233#3#2 wUDDC3##" vUTD3#22 vUDDC fUD42233##3#"! vTDCC##" eUDC3223## fTD4C3##23#"" uTDC3323#2""! 22"2" ##2"! fTDD33#22"" vUDC32"2"" WUTC22 eTD3#"" GDC32"!! eD3#"! T32"" wwwwww ffffff UUUUUU DDDDDD #4EWp "4EVx #3EVg "4DUg "#4DVg 24EVgy "34EVw ##4Efw ""3DUgw ""33DUfw ""34DVgx ""#34EVgx "#33DEfw " 234DUfw 2""2334DEVgx 3 4DEUfwx 3 DDUVgw D EUUfwx UDDEUUfgw U Vfgwx eUVfgww "%UR UD33D AD@D@ AD@D@ B"#B@ B"#B"$ 4"2$B"#B"#C 2$""#B"#C0 4"2#B"#C0 2$B"D0#C0 4""#C0 44444 CCCCC 44444 CCCCC $42" bRBBP0 @@BA@ JJJJ !BBBB "99BB #9999 $9911 %1111 &))))C '!!!! *00**- *00-00 00*0) 00*&0# ## !0*!%00+#!*0##-0'"0*#%00.! UUUUU (*)(%,3& )%+@6) ",30,)% #*>A6332+$"! 25,878 #&$690*" !)0,++)( "%/66435/'# +3;4*= !#,@9,)+,(""(-/,,*,1! !$&(265389,#!$$ '275? $*23/$ $),-..)'' !$&)(-5439@1!!&*-3/)!!%6B) )220(!$*.,,.' !$&*,*023:?B+*.,/3254.' "++,3/(.584.," !#&+/-./3:9@G@60/16883)! $++//'(9CD>4.$$ $%)*-//2693,.075-&)3792,$ ")-1347<>@G71(! **)&'*.0350+%(=A2'%)579<94( +/11! !%'),342)1?=0)" .1,$',-01)*).AG6-/048:<H /2583$%+66/% %)++*),+&%06,%$# !/40')-/31$$,@HFC<6887:==@B7%! 6A235,% +,/13.%#"(16+ !#$(04-$&+,+$ %2>D6,59:989889=0 ,.22<=33* .22671# !!&/42& *1$&+,/3779733, $$PQ /004B6* !$$ $))'/3) %&$&.7;4 )2$)*3-)466/%$ !),02+' %$5)%*+%$! (+'0:==4 $+,,1643"%)" !)/1)*+ +7=-%%&$! !3)3=. %&*/3113 !$$PQ ',4-%)/) ,6/%$$" +(!<- %),0354- .13-&,-* 14'$$! %))&%$! '3*$$" !&$%3 &%"%& 9836' )&#%%! $*)++" .-/:% !"&)()15, )" /.-+)!L //6B& #'*,.42$ $/,-*% IF1A1 "%.2/-*#! $/.,*($!#$"%PQ #57-*'$#"$&' ..//.-,)'(.212PQ ",,)&%'.;<6/+',,)%! '//,+//*)+.4:=>PQ $(&(),5?@:2/,,''*$ -!,,%.0%)./7 #43((+9CA=3+N &*)2!$96;;48@??PQ )/01%$ #3/').:@<3)$&)! /)4$%)8=A@?><@PQ !.0/.+//./1//* *.').3784/% ,,#%()25:<99=PQ %10// 0 /+134,.25653." )++-! # %0,*,384'%PQ 42//11/&(/563135650( (./36$ !"23.,27- 6:=<)&931-13-!$.69433563+ ,/258 #$,96-37)$!P 38;?B>;63/.22.-068934673( ,638<6$ *),/6."')==138*$)PQ 35:=@B>953-/1.-368<:8995& %668:9( )$'*.:&$*==8/, -19=@CA>:83+2.,0157: !""/88$ !)*# 6/0%Q &' !$*38,.<;60" +07=@CD=6>@.*)&(*-03;@@<- 6.3/% #/23989=2,*% /039>B@ "9E7,)+/3667:?CE/!" $$%199207/ 9K8@) 3933" !0042381%$(.-)56PQ 556:=@@ 5C958=BGGA96;='"+- !!%.R 94.6BDCFM='(204967& //2346% $59232$PQ :9<@?@C% 6D;;CJLONG952 (9304=FCDDE>% $,585' !.//11'$/;81$ 9:CE><D3,5G@@HF>IF94) $#%+*159C=:>FG) *31*# $/51# 89C=.!:9=C<9AFG CA7&( /%3%!'+5A<6=C>$ -672.3<<961.%! ,,%=<9/69/02. "773//33/,+) /1$'9<3)" 069850(*)'% %/+$ !&##34 %0<PQ %"$:C9.*$ !+6@PQ "$$6CD>>5 !##() ".;CPQ %'0>GFA:378+&&%$$,& ,:CPQ $(,0V 27CGG@6681//,)%$/ '7CPQ !%*/1,/44CC;6547@=2*!%.$ %;CPQ '$)=3 #%)*())3DLHB ?MB9/% ! "'6?6$ *;=PQ $%&,9D6 !$%#"&)-:FIJHFGFBN@91)%"#(,/./:/#$-46PQ !)/38;@( "$$!"+29?DGIJKMLEIC83)'&-7:73)%$!!,5:PQ +/0,$%&%%,26:5) "$%&(/7;<=BGIJIGMG=953'%(1<<63/! $*.8PQ 6=@?<3),3:8$ !&((),3=;::=EHIC:<F3)'""#&+/,', #&(0PQ FC8:CF@7/08<( "'()*,169?:6=C=2..3'" "%&)PQ HD99=A@9534/ !26(%5, ! !),''*-16<@=430/,+/)! ??979>@@:-! !$+%-*),/37<@:2/-*)+*" 4?=95;@@9& *#%.,/136884/,)'),,%)+(%$$ />C:13?@9)$ !!89+ !)$%*-/13321/,Z *3*)-/0/+&$$! 6A:0,8B=1+)/68.%/(,9=2% ")$"%)-02331/31)/().241+%##! *79/)/:<651/33)2<8.6=9. !$%,56643/75,'&).340+&#!$$%#! .5.)/46682%#$$-973:=<7 !$'+4:964063+( ,33/+(&'),*)'# "%%.2379:1&"%(&.36@?@D5 !$%')/8:86>=2)&!!-231 34772+* &46339C@4+,3/)/:<D/8J=' "%'))+336@3(/)%#%,34569<=?CE5,)! #'21\ .7@C>9;99<9@CAE05J?,%$(.33/+,/26/)(,& #,0258<?ADGE2 "'(# "%),,/6983$ &4<9+4DD>?J>/*-6;<6,,/25.))3,' ",.0369;=AGE. !%%(,.040' 2A?EA4*+/683*.493/($!/-, 0246689:AC7% $%##(.23& :96,#"%)*(%(364,%"!!"560&)/<9;989;>3$ "03., PQ UUUUUU wwwwww UUUUUU wwwwww Cancel No records match this request.E) )=400 Cancel You did not enter any find criteria; all records will be displayed.C)